{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["One Timestep Put","One Timestep Call","Two Timestep Put","Two Timestep Call","Three Timestep Put","Three Timestep Call","Euro","US"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":166,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Euro","index":6,"reason":"part_missing"},{"sheet":"US","index":7,"reason":"part_missing"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"One Timestep Put","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Stock Value",100,null,"One timestep",null,"expiration"]
["u",1.05,null,"before expiration"]
["d",0.95]
["q",{"$f":"(EXP(B6*B5)-B3)/(B2-B3)","v":0.54175359291118452},null,null,null,{"$f":"$B$2*D8","v":105}]
["dt",{"$f":"1/12","v":8.3333333333333329E-2},null,null,null,{"$f":"MAX($B$8-F4,0)","v":0}]
["r",0.05]
["PVIF",{"$f":"EXP(-B6*B5)","v":0.99584200184510996}]
["Exercise Price",100,null,{"$f":"B1","v":100}]
[null,null,null,{"$f":"$B$7*($B$4*F5+(1-$B$4)*F13)","v":2.2817050968682762}]
[null,"Stock Value",null,{"$f":"MAX(0,B8-B1)","v":0}]
[null,"European Option Value",null,{"$f":"MAX(D10,D9)","v":2.2817050968682762}]
[null,"Early Exercise Value",null,null,null,{"$f":"$B$3*D8","v":95}]
[null,"American Option Value",null,null,null,{"$f":"MAX($B$8-F12,0)","v":5}]
[]
[]
[]
["Value of Immediate Exercise",{"$f":"D10-D11","v":-2.2817050968682762}]

{"sheet":"One Timestep Call","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Stock Value",100,null,"One timestep",null,"expiration"]
["u",1.05,null,"before expiration"]
["d",0.95]
["q",{"$f":"(EXP(B6*B5)-B3)/(B2-B3)","v":0.54175359291118452},null,null,null,{"$f":"$B$2*D8","v":105}]
["dt",{"$f":"1/12","v":8.3333333333333329E-2},null,null,null,{"$f":"MAX(F4-$B$8,0)","v":5}]
["r",0.05]
["PVIF",{"$f":"EXP(-B6*B5)","v":0.99584200184510996}]
["Exercise Price",100,null,{"$f":"B1","v":100}]
[null,null,null,{"$f":"$B$7*($B$4*F5+(1-$B$4)*F13)","v":2.6975049123572736}]
[null,"Stock Value",null,{"$f":"MAX(0,B1-B8)","v":0}]
[null,"European Option Value",null,{"$f":"MAX(D10,D9)","v":2.6975049123572736}]
[null,"Early Exercise Value",null,null,null,{"$f":"$B$3*D8","v":95}]
[null,"American Option Value",null,null,null,{"$f":"MAX(F12-$B$8,0)","v":0}]
[]
[]
[]
["Value of Immediate Exercise",{"$f":"D10-D11","v":-2.6975049123572736}]
[]
[]
[]
[]
[null,null," "]

{"sheet":"Two Timestep Put","index":2,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Initial Asset Value",40,null,"Two timesteps",null,"One timestep",null,"Expiration"]
["u",1.1000000000000001,null,"before expiration",null,"before expiration"]
["d",0.9]
["q",{"$f":"(EXP(B6*B5)-B3)/(B2-B3)","v":0.65227266976758436},null,null,null,null,null,{"$f":"$B$2*F7","v":48.400000000000006}]
["dt",0.25,null,null,null,null,null,{"$f":"MAX(B$8-H4,0)","v":0}]
["r",0.12]
["PVIF",{"$f":"EXP(-B6*B5)","v":0.97044553354850815},null,null,null,{"$f":"$B$2*D10","v":44}]
["Exercise Price",42,null,null,null,{"$f":"$B$7*($B$4*H5+(1-$B$4)*H12)","v":0.80988104284030726}]
[null,null,null,null,null,{"$f":"MAX($B$8-F7,0)","v":0}]
[null,"Stock Value",null,{"$f":"B1","v":40}]
[null,"European Option Value",null,{"$f":"$B$7*($B$4*F8+(1-$B$4)*F14)","v":2.1184803010867226},null,null,null,{"$f":"$B$3*F7","v":39.6}]
[null,"Early Exercise Value",null,{"$f":"B8-B1","v":2},null,null,null,{"$f":"MAX(B$8-H11,0)","v":2.3999999999999986}]
[null,"American Option Value",null,{"$f":"$B$7*($B$4*MAX(F8,F9)+(1-$B$4)*MAX(F14,F15))","v":2.5373533380173767},null,{"$f":"$B$3*D10","v":36}]
[null,null,null,null,null,{"$f":"$B$7*($B$4*H12+(1-$B$4)*H18)","v":4.7587124090373418}]
[null,null,null,null,null,{"$f":"MAX($B$8-F13,0)","v":6}]
[]
["Value of Immediate Exercise",{"$f":"D12-D13","v":-0.53735333801737672},null,null,null,null,null,{"$f":"$B$3*F13","v":32.4}]
[null,null,null,null,null,null,null,{"$f":"MAX(B$8-H17,0)","v":9.6000000000000014}]

{"sheet":"Two Timestep Call","index":3,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Initial Asset Value",100,null,"Two timesteps",null,"One timestep",null,"Expiration"]
["u",1.05,null,"before expiration",null,"before expiration"]
["d",0.95]
["q",{"$f":"(EXP(B6*B5)-B3)/(B2-B3)","v":0.54175359291118452},null,null,null,null,null,{"$f":"$B$2*F7","v":110.25}]
["dt",{"$f":"1/12","v":8.3333333333333329E-2},null,null,null,null,null,{"$f":"MAX(H4-B$8,0)","v":10.25}]
["r",0.05]
["PVIF",{"$f":"EXP(-B6*B5)","v":0.99584200184510996},null,null,null,{"$f":"$B$2*D10","v":105}]
["Exercise Price",100,null,null,null,{"$f":"$B$7*($B$4*H5+(1-$B$4)*H12)","v":5.5298850703324112}]
[null,null,null,null,null,{"$f":"MAX(F7-$B$8,0)","v":5}]
[null,"Stock Value",null,{"$f":"B1","v":100}]
[null,"European Option Value",null,{"$f":"$B$7*($B$4*F8+(1-$B$4)*F14)","v":2.9833784283985656},null,null,null,{"$f":"$B$3*F7","v":99.75}]
[null,"Early Exercise Value",null,{"$f":"B8-B1","v":0},null,null,null,{"$f":"MAX(H11-B$8,0)","v":0}]
[null,"American Option Value",null,{"$f":"$B$7*($B$4*MAX(F8,F9)+(1-$B$4)*MAX(F14,F15))","v":2.9833784283985656},null,{"$f":"$B$3*D10","v":95}]
[null,null,null,null,null,{"$f":"$B$7*($B$4*H12+(1-$B$4)*H18)","v":0}]
[null,null,null,null,null,{"$f":"MAX(F13-$B$8,0)","v":0}]
[]
["Value of Immediate Exercise",{"$f":"D12-D13","v":-2.9833784283985656},null,null,null,null,null,{"$f":"$B$3*F13","v":90.25}]
[null,null,null,null,null,null,null,{"$f":"MAX(H17-B$8,0)","v":0}]

{"sheet":"Three Timestep Put","index":4,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Initial Asset Value",100,null,"Two timesteps",null,"One timestep",null,"Two timesteps",null,"Expiration"]
["u",1.05,null,"before expiration",null,"before expiration",null,"before expiration",null,{"$f":"$B$2*H4","v":115.7625}]
["d",0.95,null,null,null,null,null,null,null,{"$f":"MAX(B$8-J2,0)","v":0}]
["q",{"$f":"(EXP(B6*B5)-B3)/(B2-B3)","v":0.54175359291118452},null,null,null,null,null,{"$f":"$B$2*F7","v":110.25}]
["dt",{"$f":"1/12","v":8.3333333333333329E-2},null,null,null,null,null,{"$f":"$B$7*($B$4*J3+(1-$B$4)*J9)","v":0}]
["r",0.05,null,null,null,null,null,{"$f":"MAX($B$8-H4,0)","v":0}]
["PVIF",{"$f":"EXP(-B6*B5)","v":0.99584200184510996},null,null,null,{"$f":"$B$2*D10","v":105}]
["Exercise Price",100,null,null,null,{"$f":"$B$7*($B$4*H5+(1-$B$4)*H12)","v":1.0906943222311452},null,null,null,{"$f":"$B$3*H4","v":104.7375}]
[null,null,null,null,null,{"$f":"MAX($B$8-F7,0)","v":0},null,null,null,{"$f":"MAX(B$8-J8,0)","v":0}]
[null,"Stock Value",null,{"$f":"B1","v":100},null,{"$f":"MAX($B$8-F7,$B$7*($B$4*MAX(H6,H7)+(1-$B$4)*MAX(H12,H13)))","v":1.0906943222311452}]
[null,"European Option Value",null,{"$f":"$B$7*($B$4*F8+(1-$B$4)*F14)","v":3.1206816784270788},null,null,null,{"$f":"$B$3*F7","v":99.75}]
[null,"Early Exercise Value",null,{"$f":"MAX($B$8-D10,0)","v":0},null,null,null,{"$f":"$B$7*($B$4*J9+(1-$B$4)*J15)","v":2.3900860889695239}]
[null,"American Option Value",null,{"$f":"$B$7*($B$4*MAX(F8,F10)+(1-$B$4)*MAX(F14,F16))","v":3.2072707949786019},null,{"$f":"$B$3*D10","v":95},null,{"$f":"MAX($B$8-H11,$B$7*($B$4*J10+(1-$B$4)*J17))","v":0.25}]
[null,null,null,null,null,{"$f":"$B$7*($B$4*H12+(1-$B$4)*H18)","v":5.5490322204279297},null,null,null,{"$f":"$B$3*H11","v":94.762499999999989}]
[null,null,null,null,null,{"$f":"MAX($B$8-F13,0)","v":5},null,null,null,{"$f":"MAX(B$8-J14,0)","v":5.2375000000000114}]
[null,null,null,null,null,{"$f":"MAX($B$8-F13,$B$7*($B$4*MAX(H12,H13)+(1-$B$4)*MAX(H18,H19)))","v":5.7387787320835537}]
["Value of Immediate Exercise",{"$f":"D12-D13","v":-3.2072707949786019},null,null,null,null,null,{"$f":"$B$3*F13","v":90.25}]
[null,null,null,null,null,null,null,{"$f":"$B$7*($B$4*J15+(1-$B$4)*J20)","v":9.3342001845110101}]
[null,null,null,null,null,null,null,{"$f":"MAX($B$8-H17,$B$7*($B$4*J16+(1-$B$4)*J23))","v":9.75},null,{"$f":"$B$3*H17","v":85.737499999999997}]
[null,null,null,null,null,null,null,null,null,{"$f":"MAX(B$8-J19,0)","v":14.262500000000003}]

{"sheet":"Three Timestep Call","index":5,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Initial Asset Value",100,null,"Two timesteps",null,"One timestep",null,"Two timesteps",null,"Expiration"]
["u",1.05,null,"before expiration",null,"before expiration",null,"before expiration",null,{"$f":"$B$2*H4","v":115.7625}]
["d",0.95,null,null,null,null,null,null,null,{"$f":"MAX(J2-B$8,0)","v":15.762500000000003}]
["q",{"$f":"(EXP(B6*B5)-B3)/(B2-B3)","v":0.54175359291118452},null,null,null,null,null,{"$f":"$B$2*F7","v":110.25}]
["dt",{"$f":"1/12","v":8.3333333333333329E-2},null,null,null,null,null,{"$f":"$B$7*($B$4*J3+(1-$B$4)*J9)","v":10.665799815488999}]
["r",0.05,null,null,null,null,null,{"$f":"MAX(H4-$B$8,0)","v":10.25}]
["PVIF",{"$f":"EXP(-B6*B5)","v":0.99584200184510996},null,null,null,{"$f":"$B$2*D10","v":105}]
["Exercise Price",100,null,null,null,{"$f":"$B$7*($B$4*H5+(1-$B$4)*H12)","v":6.9205650583435316},null,null,null,{"$f":"$B$3*H4","v":104.7375}]
[null,null,null,null,null,{"$f":"MAX(F7-$B$8,0)","v":5},null,null,null,{"$f":"MAX(J8-B$8,0)","v":4.7374999999999972}]
[null,"Stock Value",null,{"$f":"B1","v":100},null,{"$f":"MAX($B$8-F7,$B$7*($B$4*MAX(H5,H6)+(1-$B$4)*MAX(H12,H13)))","v":6.9205650583435316}]
[null,"European Option Value",null,{"$f":"$B$7*($B$4*F8+(1-$B$4)*F14)","v":4.3629016290389089},null,null,null,{"$f":"$B$3*F7","v":99.75}]
[null,"Early Exercise Value",null,{"$f":"MAX($B$8-D10,0)","v":0},null,null,null,{"$f":"$B$7*($B$4*J9+(1-$B$4)*J15)","v":2.5558859044585156}]
[null,"American Option Value",null,{"$f":"$B$7*($B$4*MAX(F8,F10)+(1-$B$4)*MAX(F14,F16))","v":4.3629016290389089},null,{"$f":"$B$3*D10","v":95},null,{"$f":"MAX(H11-$B$8,0)","v":0}]
[null,null,null,null,null,{"$f":"$B$7*($B$4*H12+(1-$B$4)*H18)","v":1.3789029565403119},null,null,null,{"$f":"$B$3*H11","v":94.762499999999989}]
[null,null,null,null,null,{"$f":"MAX(F13-$B$8,0)","v":0},null,null,null,{"$f":"MAX(J14-B$8,0)","v":0}]
[null,null,null,null,null,{"$f":"$B$7*($B$4*MAX(H12,H13)+(1-$B$4)*MAX(H18,H19))","v":1.3789029565403119}]
["Value of Immediate Exercise",{"$f":"D12-D13","v":-4.3629016290389089},null,null,null,null,null,{"$f":"$B$3*F13","v":90.25}]
[null,null,null,null,null,null,null,{"$f":"$B$7*($B$4*J15+(1-$B$4)*J20)","v":0}]
[null,null,null,null,null,null,null,{"$f":"MAX(H17-$B$8,0)","v":0},null,{"$f":"$B$3*H17","v":85.737499999999997}]
[null,null,null,null,null,null,null,null,null,{"$f":"MAX(J19-B$8,0)","v":0}]